LOAD DATA 
 INFILE predios.dat
 TRUNCATE
 CONTINUEIF NEXT(1:1) = '#'
 INTO TABLE PREDIOS
 FIELDS TERMINATED BY '|'
 TRAILING NULLCOLS (
   Id,
   chip 	NULLIF chip = BLANKS,
   propietari 	NULLIF propietari = BLANKS,
   tipo_doc,
   n_doc,
   area,
   GEO COLUMN OBJECT 
   (
     SDO_GTYPE       INTEGER EXTERNAL, 
     SDO_ELEM_INFO   VARRAY TERMINATED BY '|/' 
       (X            FLOAT EXTERNAL), 
     SDO_ORDINATES   VARRAY TERMINATED BY '|/' 
       (X            FLOAT EXTERNAL) 
   )
)
